Data Profiling Report After Initial Cleaning

Dataset statistics

Number of variables	28
Number of observations	1786867
Missing cells	126678
Missing cells (%)	0.3%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	276.1 MiB
Average record size in memory	162.0 B

Variable types

Numeric	16
Categorical	10
Text	1
DateTime	1

Alerts

`addr_state` has a high cardinality: 51 distinct values	High cardinality
`application_type` is highly imbalanced (76.5%)	Imbalance
`emp_title` has 126678 (7.1%) missing values	Missing
`acc_now_delinq` is highly skewed (γ1 = 21.53739225)	Skewed
`annual_inc` is highly skewed (γ1 = 516.2230369)	Skewed
`dti` is highly skewed (γ1 = 29.7500553)	Skewed
`acc_now_delinq` has 1779026 (99.6%) zeros	Zeros
`bc_util` has 23438 (1.3%) zeros	Zeros
`delinq_2yrs` has 1444417 (80.8%) zeros	Zeros
`inq_last_6mths` has 1061742 (59.4%) zeros	Zeros
`pub_rec` has 1483020 (83.0%) zeros	Zeros
`pub_rec_bankruptcies` has 1558818 (87.2%) zeros	Zeros

Reproduction

Analysis started	2024-07-10 03:22:50.003932
Analysis finished	2024-07-10 03:23:27.562539
Duration	37.56 seconds
Software version	ydata-profiling v4.8.3
Download configuration	config.json

acc_now_delinq
Real number (ℝ)

SKEWED ZEROS

Distinct	8
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.0046869745

Minimum	0
Maximum	14
Zeros	1779026
Zeros (%)	99.6%
Negative	0
Negative (%)	0.0%
Memory size	27.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	14
Range	14
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.073950328
Coefficient of variation (CV)	15.777839
Kurtosis	1143.1848
Mean	0.0046869745
Median Absolute Deviation (MAD)	0
Skewness	21.537392
Sum	8375
Variance	0.005468651
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
0	1779026	99.6%
1	7399	0.4%
2	381	< 0.1%
3	45	< 0.1%
4	11	< 0.1%
5	3	< 0.1%
6	1	< 0.1%
14	1	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1779026	99.6%
1	7399	0.4%
2	381	< 0.1%
3	45	< 0.1%
4	11	< 0.1%
5	3	< 0.1%
6	1	< 0.1%
14	1	< 0.1%

Value	Count	Frequency (%)
14	1	< 0.1%
6	1	< 0.1%
5	3	< 0.1%
4	11	< 0.1%
3	45	< 0.1%
2	381	< 0.1%
1	7399	0.4%
0	1779026	99.6%

addr_state
Categorical

HIGH CARDINALITY

Distinct	51
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	15.3 MiB

CA	251979
TX	147621
NY	144564
FL	128673
IL	70007
Other values (46)	1044023

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	3573734
Distinct characters	24
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	NC
2nd row	TX
3rd row	MI
4th row	TX
5th row	NC

Common Values

Value	Count	Frequency (%)
CA	251979	14.1%
TX	147621	8.3%
NY	144564	8.1%
FL	128673	7.2%
IL	70007	3.9%
NJ	64130	3.6%
PA	60061	3.4%
OH	58818	3.3%
GA	58086	3.3%
NC	50071	2.8%
Other values (41)	752857	42.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
ca	251979	14.1%
tx	147621	8.3%
ny	144564	8.1%
fl	128673	7.2%
il	70007	3.9%
nj	64130	3.6%
pa	60061	3.4%
oh	58818	3.3%
ga	58086	3.3%
nc	50071	2.8%
Other values (41)	752857	42.1%

Most occurring characters

Value	Count	Frequency (%)
A	601485	16.8%
N	404030	11.3%
C	393768	11.0%
L	240559	6.7%
T	224948	6.3%
M	217813	6.1%
I	191235	5.4%
Y	165597	4.6%
O	164254	4.6%
X	147621	4.1%
Other values (14)	822424	23.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	3573734	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
A	601485	16.8%
N	404030	11.3%
C	393768	11.0%
L	240559	6.7%
T	224948	6.3%
M	217813	6.1%
I	191235	5.4%
Y	165597	4.6%
O	164254	4.6%
X	147621	4.1%
Other values (14)	822424	23.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	3573734	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
A	601485	16.8%
N	404030	11.3%
C	393768	11.0%
L	240559	6.7%
T	224948	6.3%
M	217813	6.1%
I	191235	5.4%
Y	165597	4.6%
O	164254	4.6%
X	147621	4.1%
Other values (14)	822424	23.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	3573734	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
A	601485	16.8%
N	404030	11.3%
C	393768	11.0%
L	240559	6.7%
T	224948	6.3%
M	217813	6.1%
I	191235	5.4%
Y	165597	4.6%
O	164254	4.6%
X	147621	4.1%
Other values (14)	822424	23.0%

annual_inc
Real number (ℝ)

SKEWED

Distinct	76713
Distinct (%)	4.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	77860.225

Minimum	0
Maximum	1.1 × 10⁸
Zeros	4
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	27.3 MiB

Quantile statistics

Minimum	0
5-th percentile	28000
Q1	46500
median	65000
Q3	93000
95-th percentile	160000
Maximum	1.1 × 10⁸
Range	1.1 × 10⁸
Interquartile range (IQR)	46500

Descriptive statistics

Standard deviation	119837.41
Coefficient of variation (CV)	1.5391351
Kurtosis	434186.59
Mean	77860.225
Median Absolute Deviation (MAD)	21699
Skewness	516.22304
Sum	1.3912587 × 10¹¹
Variance	1.4361004 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
60000	69034	3.9%
50000	60705	3.4%
65000	52069	2.9%
70000	49607	2.8%
80000	47525	2.7%
40000	47157	2.6%
75000	46419	2.6%
45000	43560	2.4%
55000	41464	2.3%
100000	37094	2.1%
Other values (76703)	1292233	72.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	4	< 0.1%
15	1	< 0.1%
16	1	< 0.1%
20	2	< 0.1%
23	1	< 0.1%
25	1	< 0.1%
32	1	< 0.1%
33	1	< 0.1%
39	1	< 0.1%
50	1	< 0.1%

Value	Count	Frequency (%)
110000000	1	< 0.1%
61000000	1	< 0.1%
10999200	1	< 0.1%
9573072	1	< 0.1%
9550000	1	< 0.1%
9522972	1	< 0.1%
9500000	1	< 0.1%
9300000	1	< 0.1%
9225000	1	< 0.1%
9100000	1	< 0.1%

application_type
Categorical

IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	15.3 MiB

Individual	1718155
Joint App	68712

Length

Max length	10
Median length	10
Mean length	9.9615461
Min length	9

Characters and Unicode

Total characters	17799958
Distinct characters	14
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Individual
2nd row	Individual
3rd row	Individual
4th row	Individual
5th row	Individual

Common Values

Value	Count	Frequency (%)
Individual	1718155	96.2%
Joint App	68712	3.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
individual	1718155	92.6%
joint	68712	3.7%
app	68712	3.7%

Most occurring characters

Value	Count	Frequency (%)
i	3505022	19.7%
d	3436310	19.3%
n	1786867	10.0%
I	1718155	9.7%
v	1718155	9.7%
u	1718155	9.7%
a	1718155	9.7%
l	1718155	9.7%
p	137424	0.8%
J	68712	0.4%
Other values (4)	274848	1.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	17799958	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
i	3505022	19.7%
d	3436310	19.3%
n	1786867	10.0%
I	1718155	9.7%
v	1718155	9.7%
u	1718155	9.7%
a	1718155	9.7%
l	1718155	9.7%
p	137424	0.8%
J	68712	0.4%
Other values (4)	274848	1.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	17799958	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
i	3505022	19.7%
d	3436310	19.3%
n	1786867	10.0%
I	1718155	9.7%
v	1718155	9.7%
u	1718155	9.7%
a	1718155	9.7%
l	1718155	9.7%
p	137424	0.8%
J	68712	0.4%
Other values (4)	274848	1.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	17799958	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
i	3505022	19.7%
d	3436310	19.3%
n	1786867	10.0%
I	1718155	9.7%
v	1718155	9.7%
u	1718155	9.7%
a	1718155	9.7%
l	1718155	9.7%
p	137424	0.8%
J	68712	0.4%
Other values (4)	274848	1.5%

avg_cur_bal
Real number (ℝ)

Distinct	83451
Distinct (%)	4.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	13459.29

Minimum	0
Maximum	555925
Zeros	624
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	27.3 MiB

Quantile statistics

Minimum	0
5-th percentile	1078
Q1	3077
median	7346
Q3	18709
95-th percentile	43141
Maximum	555925
Range	555925
Interquartile range (IQR)	15632

Descriptive statistics

Standard deviation	16157.496
Coefficient of variation (CV)	1.2004716
Kurtosis	28.751143
Mean	13459.29
Median Absolute Deviation (MAD)	5375
Skewness	3.4881532
Sum	2.4049962 × 10¹⁰
Variance	2.6106468 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	624	< 0.1%
1971	232	< 0.1%
2253	228	< 0.1%
2076	226	< 0.1%
2447	224	< 0.1%
2301	223	< 0.1%
2149	222	< 0.1%
2842	222	< 0.1%
2606	220	< 0.1%
2079	220	< 0.1%
Other values (83441)	1784226	99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	624	< 0.1%
1	53	< 0.1%
2	48	< 0.1%
3	51	< 0.1%
4	26	< 0.1%
5	45	< 0.1%
6	38	< 0.1%
7	29	< 0.1%
8	30	< 0.1%
9	32	< 0.1%

Value	Count	Frequency (%)
555925	1	< 0.1%
502002	1	< 0.1%
498284	1	< 0.1%
497484	1	< 0.1%
478909	1	< 0.1%
477255	1	< 0.1%
466840	1	< 0.1%
463945	1	< 0.1%
463276	1	< 0.1%
447102	1	< 0.1%

bc_util
Real number (ℝ)

ZEROS

Distinct	1476
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	58.043113

Minimum	0
Maximum	339.6
Zeros	23438
Zeros (%)	1.3%
Negative	0
Negative (%)	0.0%
Memory size	27.3 MiB

Quantile statistics

Minimum	0
5-th percentile	7.4
Q1	35.5
median	60.6
Q3	83.4
95-th percentile	97.9
Maximum	339.6
Range	339.6
Interquartile range (IQR)	47.9

Descriptive statistics

Standard deviation	28.710216
Coefficient of variation (CV)	0.49463604
Kurtosis	-0.99604539
Mean	58.043113
Median Absolute Deviation (MAD)	23.8
Skewness	-0.28097288
Sum	1.0371532 × 10⁸
Variance	824.27647
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	23438	1.3%
98	4968	0.3%
97	4671	0.3%
99	4595	0.3%
96	4528	0.3%
95	4191	0.2%
94	3985	0.2%
93	3797	0.2%
92	3684	0.2%
91	3555	0.2%
Other values (1466)	1725455	96.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	23438	1.3%
0.1	1959	0.1%
0.2	1709	0.1%
0.3	1449	0.1%
0.4	1253	0.1%
0.5	1198	0.1%
0.6	1092	0.1%
0.7	1076	0.1%
0.8	1031	0.1%
0.9	971	0.1%

Value	Count	Frequency (%)
339.6	1	< 0.1%
318.2	1	< 0.1%
255.2	1	< 0.1%
252.3	1	< 0.1%
243.8	1	< 0.1%
235.3	1	< 0.1%
204.6	1	< 0.1%
202.9	1	< 0.1%
202	1	< 0.1%
201.9	1	< 0.1%

delinq_2yrs
Real number (ℝ)

ZEROS

Distinct	34
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.31676112

Minimum	0
Maximum	39
Zeros	1444417
Zeros (%)	80.8%
Negative	0
Negative (%)	0.0%
Memory size	27.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	2
Maximum	39
Range	39
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.88076313
Coefficient of variation (CV)	2.7805279
Kurtosis	60.149821
Mean	0.31676112
Median Absolute Deviation (MAD)	0
Skewness	5.673827
Sum	566010
Variance	0.7757437
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=34)

Value	Count	Frequency (%)
0	1444417	80.8%
1	227702	12.7%
2	66278	3.7%
3	24237	1.4%
4	10843	0.6%
5	5454	0.3%
6	3099	0.2%
7	1710	0.1%
8	1050	0.1%
9	651	< 0.1%
Other values (24)	1426	0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1444417	80.8%
1	227702	12.7%
2	66278	3.7%
3	24237	1.4%
4	10843	0.6%
5	5454	0.3%
6	3099	0.2%
7	1710	0.1%
8	1050	0.1%
9	651	< 0.1%

Value	Count	Frequency (%)
39	1	< 0.1%
36	1	< 0.1%
32	1	< 0.1%
30	1	< 0.1%
29	2	< 0.1%
28	1	< 0.1%
27	1	< 0.1%
26	3	< 0.1%
25	2	< 0.1%
24	1	< 0.1%

dti
Real number (ℝ)

SKEWED

Distinct	9396
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	18.753862

Minimum	-1
Maximum	999
Zeros	984
Zeros (%)	0.1%
Negative	2
Negative (%)	< 0.1%
Memory size	27.3 MiB

Quantile statistics

Minimum	-1
5-th percentile	5.06
Q1	11.97
median	17.88
Q3	24.52
95-th percentile	33.61
Maximum	999
Range	1000
Interquartile range (IQR)	12.55

Descriptive statistics

Standard deviation	13.283835
Coefficient of variation (CV)	0.70832532
Kurtosis	1925.3093
Mean	18.753862
Median Absolute Deviation (MAD)	6.24
Skewness	29.750055
Sum	33510657
Variance	176.46028
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
19.2	1282	0.1%
14.4	1262	0.1%
18	1254	0.1%
16.8	1247	0.1%
13.2	1197	0.1%
15.6	1195	0.1%
20.4	1164	0.1%
12	1151	0.1%
21.6	1126	0.1%
10.8	1061	0.1%
Other values (9386)	1774928	99.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-1	2	< 0.1%
0	984	0.1%
0.01	12	< 0.1%
0.02	24	< 0.1%
0.03	14	< 0.1%
0.04	9	< 0.1%
0.05	15	< 0.1%
0.06	28	< 0.1%
0.07	20	< 0.1%
0.08	22	< 0.1%

Value	Count	Frequency (%)
999	90	< 0.1%
994.4	1	< 0.1%
991.57	1	< 0.1%
962.83	1	< 0.1%
962.12	1	< 0.1%
942.17	1	< 0.1%
917.87	1	< 0.1%
893.1	1	< 0.1%
886.77	1	< 0.1%
879.55	1	< 0.1%

emp_length
Categorical

Distinct	11
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	15.3 MiB

10	592270
0	260701
2	161222
3	142893
1	117587
Other values (6)	512194

Length

Max length	2
Median length	1
Mean length	1.3314572
Min length	1

Characters and Unicode

Total characters	2379137
Distinct characters	10
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	4
2nd row	2
3rd row	10
4th row	3
5th row	4

Common Values

Value	Count	Frequency (%)
10	592270	33.1%
0	260701	14.6%
2	161222	9.0%
3	142893	8.0%
1	117587	6.6%
5	109864	6.1%
4	106403	6.0%
6	80982	4.5%
8	75735	4.2%
7	74552	4.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
10	592270	33.1%
0	260701	14.6%
2	161222	9.0%
3	142893	8.0%
1	117587	6.6%
5	109864	6.1%
4	106403	6.0%
6	80982	4.5%
8	75735	4.2%
7	74552	4.2%

Most occurring characters

Value	Count	Frequency (%)
0	852971	35.9%
1	709857	29.8%
2	161222	6.8%
3	142893	6.0%
5	109864	4.6%
4	106403	4.5%
6	80982	3.4%
8	75735	3.2%
7	74552	3.1%
9	64658	2.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2379137	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	852971	35.9%
1	709857	29.8%
2	161222	6.8%
3	142893	6.0%
5	109864	4.6%
4	106403	4.5%
6	80982	3.4%
8	75735	3.2%
7	74552	3.1%
9	64658	2.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2379137	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	852971	35.9%
1	709857	29.8%
2	161222	6.8%
3	142893	6.0%
5	109864	4.6%
4	106403	4.5%
6	80982	3.4%
8	75735	3.2%
7	74552	3.1%
9	64658	2.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2379137	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	852971	35.9%
1	709857	29.8%
2	161222	6.8%
3	142893	6.0%
5	109864	4.6%
4	106403	4.5%
6	80982	3.4%
8	75735	3.2%
7	74552	3.1%
9	64658	2.7%

emp_title
Text

MISSING

Distinct	355971
Distinct (%)	21.4%
Missing	126678
Missing (%)	7.1%
Memory size	27.3 MiB

Length

Max length	42
Median length	32
Mean length	15.478738
Min length	1

Characters and Unicode

Total characters	25697630
Distinct characters	131
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	269961 ?
Unique (%)	16.3%

Sample

1st row	PROJECT_MANAGER
2nd row	SURGICAL_TECHNICIAN
3rd row	TEAM_LEADERN_CUSTOMER_OPS_&_SYSTEMS
4th row	SYSTEMS_ENGINEER
5th row	ASSISTANT_DIRECTOR_-_HUMAN_RESOURCES

Value	Count	Frequency (%)
teacher	38171	2.3%
manager	37532	2.3%
nurse	36542	2.2%
owner	24817	1.5%
supervisor	18084	1.1%
driver	18050	1.1%
sales	15634	0.9%
office_manager	11337	0.7%
project_manager	11231	0.7%
general_manager	10765	0.6%
Other values (332524)	1438045	86.6%

Most occurring characters

Value	Count	Frequency (%)
E	2939401	11.4%
R	2403245	9.4%
A	2383501	9.3%
I	1924834	7.5%
N	1870482	7.3%
_	1847705	7.2%
T	1809960	7.0%
S	1714660	6.7%
O	1449712	5.6%
C	1398838	5.4%
Other values (121)	5955292	23.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	25697630	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
E	2939401	11.4%
R	2403245	9.4%
A	2383501	9.3%
I	1924834	7.5%
N	1870482	7.3%
_	1847705	7.2%
T	1809960	7.0%
S	1714660	6.7%
O	1449712	5.6%
C	1398838	5.4%
Other values (121)	5955292	23.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	25697630	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
E	2939401	11.4%
R	2403245	9.4%
A	2383501	9.3%
I	1924834	7.5%
N	1870482	7.3%
_	1847705	7.2%
T	1809960	7.0%
S	1714660	6.7%
O	1449712	5.6%
C	1398838	5.4%
Other values (121)	5955292	23.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	25697630	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
E	2939401	11.4%
R	2403245	9.4%
A	2383501	9.3%
I	1924834	7.5%
N	1870482	7.3%
_	1847705	7.2%
T	1809960	7.0%
S	1714660	6.7%
O	1449712	5.6%
C	1398838	5.4%
Other values (121)	5955292	23.2%

fico_range_high
Real number (ℝ)

Distinct	38
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	701.17936

Minimum	664
Maximum	850
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	27.3 MiB

Quantile statistics

Minimum	664
5-th percentile	664
Q1	674
median	694
Q3	719
95-th percentile	769
Maximum	850
Range	186
Interquartile range (IQR)	45

Descriptive statistics

Standard deviation	32.47601
Coefficient of variation (CV)	0.046316267
Kurtosis	1.5491764
Mean	701.17936
Median Absolute Deviation (MAD)	20
Skewness	1.2591692
Sum	1.2529143 × 10⁹
Variance	1054.6913
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=38)

Value	Count	Frequency (%)
664	156140	8.7%
674	151186	8.5%
669	150637	8.4%
684	135122	7.6%
679	135050	7.6%
689	118766	6.6%
694	115689	6.5%
699	103958	5.8%
704	97075	5.4%
709	88066	4.9%
Other values (28)	535178	30.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
664	156140	8.7%
669	150637	8.4%
674	151186	8.5%
679	135050	7.6%
684	135122	7.6%
689	118766	6.6%
694	115689	6.5%
699	103958	5.8%
704	97075	5.4%
709	88066	4.9%

Value	Count	Frequency (%)
850	306	< 0.1%
844	400	< 0.1%
839	623	< 0.1%
834	1077	0.1%
829	1611	0.1%
824	2128	0.1%
819	2924	0.2%
814	3470	0.2%
809	4846	0.3%
804	5724	0.3%

fico_range_low
Real number (ℝ)

Distinct	38
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	697.17919

Minimum	660
Maximum	845
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	27.3 MiB

Quantile statistics

Minimum	660
5-th percentile	660
Q1	670
median	690
Q3	715
95-th percentile	765
Maximum	845
Range	185
Interquartile range (IQR)	45

Descriptive statistics

Standard deviation	32.475228
Coefficient of variation (CV)	0.046580892
Kurtosis	1.5476317
Mean	697.17919
Median Absolute Deviation (MAD)	20
Skewness	1.258946
Sum	1.2457665 × 10⁹
Variance	1054.6405
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=38)

Value	Count	Frequency (%)
660	156140	8.7%
670	151186	8.5%
665	150637	8.4%
680	135122	7.6%
675	135050	7.6%
685	118766	6.6%
690	115689	6.5%
695	103958	5.8%
700	97075	5.4%
705	88066	4.9%
Other values (28)	535178	30.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
660	156140	8.7%
665	150637	8.4%
670	151186	8.5%
675	135050	7.6%
680	135122	7.6%
685	118766	6.6%
690	115689	6.5%
695	103958	5.8%
700	97075	5.4%
705	88066	4.9%

Value	Count	Frequency (%)
845	306	< 0.1%
840	400	< 0.1%
835	623	< 0.1%
830	1077	0.1%
825	1611	0.1%
820	2128	0.1%
815	2924	0.2%
810	3470	0.2%
805	4846	0.3%
800	5724	0.3%

grade
Categorical

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	15.3 MiB

B	523797
C	512850
A	329095
D	265392
E	110811
Other values (2)	44922

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	1786867
Distinct characters	7
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	B
2nd row	B
3rd row	B
4th row	A
5th row	B

Common Values

Value	Count	Frequency (%)
B	523797	29.3%
C	512850	28.7%
A	329095	18.4%
D	265392	14.9%
E	110811	6.2%
F	34874	2.0%
G	10048	0.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
b	523797	29.3%
c	512850	28.7%
a	329095	18.4%
d	265392	14.9%
e	110811	6.2%
f	34874	2.0%
g	10048	0.6%

Most occurring characters

Value	Count	Frequency (%)
B	523797	29.3%
C	512850	28.7%
A	329095	18.4%
D	265392	14.9%
E	110811	6.2%
F	34874	2.0%
G	10048	0.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1786867	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
B	523797	29.3%
C	512850	28.7%
A	329095	18.4%
D	265392	14.9%
E	110811	6.2%
F	34874	2.0%
G	10048	0.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1786867	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
B	523797	29.3%
C	512850	28.7%
A	329095	18.4%
D	265392	14.9%
E	110811	6.2%
F	34874	2.0%
G	10048	0.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1786867	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
B	523797	29.3%
C	512850	28.7%
A	329095	18.4%
D	265392	14.9%
E	110811	6.2%
F	34874	2.0%
G	10048	0.6%

home_ownership
Categorical

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	15.3 MiB

MORTGAGE	883347
RENT	702476
OWN	199747
ANY	1208
NONE	45

Length

Max length	8
Median length	5
Mean length	5.8649832
Min length	3

Characters and Unicode

Total characters	10479945
Distinct characters	11
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	RENT
2nd row	MORTGAGE
3rd row	OWN
4th row	MORTGAGE
5th row	RENT

Common Values

Value	Count	Frequency (%)
MORTGAGE	883347	49.4%
RENT	702476	39.3%
OWN	199747	11.2%
ANY	1208	0.1%
NONE	45	< 0.1%
OTHER	44	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
mortgage	883347	49.4%
rent	702476	39.3%
own	199747	11.2%
any	1208	0.1%
none	45	< 0.1%
other	44	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
G	1766694	16.9%
E	1585912	15.1%
R	1585867	15.1%
T	1585867	15.1%
O	1083183	10.3%
N	903521	8.6%
A	884555	8.4%
M	883347	8.4%
W	199747	1.9%
Y	1208	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	10479945	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
G	1766694	16.9%
E	1585912	15.1%
R	1585867	15.1%
T	1585867	15.1%
O	1083183	10.3%
N	903521	8.6%
A	884555	8.4%
M	883347	8.4%
W	199747	1.9%
Y	1208	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	10479945	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
G	1766694	16.9%
E	1585912	15.1%
R	1585867	15.1%
T	1585867	15.1%
O	1083183	10.3%
N	903521	8.6%
A	884555	8.4%
M	883347	8.4%
W	199747	1.9%
Y	1208	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	10479945	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
G	1766694	16.9%
E	1585912	15.1%
R	1585867	15.1%
T	1585867	15.1%
O	1083183	10.3%
N	903521	8.6%
A	884555	8.4%
M	883347	8.4%
W	199747	1.9%
Y	1208	< 0.1%

inq_last_6mths
Real number (ℝ)

ZEROS

Distinct	9
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.60544126

Minimum	0
Maximum	8
Zeros	1061742
Zeros (%)	59.4%
Negative	0
Negative (%)	0.0%
Memory size	27.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	2
Maximum	8
Range	8
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.89568327
Coefficient of variation (CV)	1.4793892
Kurtosis	3.5645006
Mean	0.60544126
Median Absolute Deviation (MAD)	0
Skewness	1.7586611
Sum	1081843
Variance	0.80224853
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=9)

Value	Count	Frequency (%)
0	1061742	59.4%
1	477811	26.7%
2	167065	9.3%
3	58273	3.3%
4	15665	0.9%
5	5448	0.3%
6	859	< 0.1%
7	3	< 0.1%
8	1	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1061742	59.4%
1	477811	26.7%
2	167065	9.3%
3	58273	3.3%
4	15665	0.9%
5	5448	0.3%
6	859	< 0.1%
7	3	< 0.1%
8	1	< 0.1%

Value	Count	Frequency (%)
8	1	< 0.1%
7	3	< 0.1%
6	859	< 0.1%
5	5448	0.3%
4	15665	0.9%
3	58273	3.3%
2	167065	9.3%
1	477811	26.7%
0	1061742	59.4%

installment
Real number (ℝ)

Distinct	88618
Distinct (%)	5.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	444.74625

Minimum	4.93
Maximum	1719.83
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	27.3 MiB

Quantile statistics

Minimum	4.93
5-th percentile	109.86
Q1	250.33
median	377.04
Q3	591.205
95-th percentile	988.42
Maximum	1719.83
Range	1714.9
Interquartile range (IQR)	340.875

Descriptive statistics

Standard deviation	267.81855
Coefficient of variation (CV)	0.60218281
Kurtosis	0.70534339
Mean	444.74625
Median Absolute Deviation (MAD)	158
Skewness	1.0095919
Sum	7.9470239 × 10⁸
Variance	71726.773
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
301.15	3862	0.2%
332.1	3382	0.2%
327.34	3281	0.2%
361.38	3173	0.2%
602.3	2739	0.2%
451.73	2738	0.2%
329.72	2562	0.1%
318.79	2280	0.1%
312.86	2181	0.1%
392.81	2168	0.1%
Other values (88608)	1758501	98.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
4.93	1	< 0.1%
7.61	1	< 0.1%
14.01	1	< 0.1%
14.77	1	< 0.1%
19.4	1	< 0.1%
20.11	1	< 0.1%
23.26	1	< 0.1%
23.36	1	< 0.1%
25.81	1	< 0.1%
25.86	1	< 0.1%

Value	Count	Frequency (%)
1719.83	2	< 0.1%
1717.63	1	< 0.1%
1715.42	2	< 0.1%
1714.54	4	< 0.1%
1691.28	2	< 0.1%
1676.23	2	< 0.1%
1671.88	2	< 0.1%
1670.15	1	< 0.1%
1664.57	1	< 0.1%
1647.03	1	< 0.1%

int_rate
Real number (ℝ)

Distinct	395
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.13194428

Minimum	0.0531
Maximum	0.3099
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	27.3 MiB

Quantile statistics

Minimum	0.0531
5-th percentile	0.0649
Q1	0.0949
median	0.1269
Q3	0.1599
95-th percentile	0.2239
Maximum	0.3099
Range	0.2568
Interquartile range (IQR)	0.065

Descriptive statistics

Standard deviation	0.048550742
Coefficient of variation (CV)	0.36796397
Kurtosis	0.54913972
Mean	0.13194428
Median Absolute Deviation (MAD)	0.0325
Skewness	0.75727745
Sum	235766.89
Variance	0.0023571746
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.1199	41995	2.4%
0.0532	41651	2.3%
0.1099	41309	2.3%
0.1399	36842	2.1%
0.1149	29489	1.7%
0.1699	28203	1.6%
0.1299	27678	1.5%
0.0789	27372	1.5%
0.0917	26929	1.5%
0.1561	24268	1.4%
Other values (385)	1461131	81.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0531	3301	0.2%
0.0532	41651	2.3%
0.0593	1809	0.1%
0.06	602	< 0.1%
0.0603	9250	0.5%
0.0607	2234	0.1%
0.0608	2947	0.2%
0.0611	3854	0.2%
0.0619	1330	0.1%
0.0624	7456	0.4%

Value	Count	Frequency (%)
0.3099	667	< 0.1%
0.3094	574	< 0.1%
0.3089	544	< 0.1%
0.3084	609	< 0.1%
0.3079	1165	0.1%
0.3075	755	< 0.1%
0.3074	394	< 0.1%
0.3065	697	< 0.1%
0.3049	446	< 0.1%
0.3017	846	< 0.1%

issue_d
Date

Distinct	98
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	27.3 MiB

Minimum	2012-08-01 00:00:00
Maximum	2020-09-01 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

loan_amnt
Real number (ℝ)

Distinct	1561
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	14740.787

Minimum	1000
Maximum	40000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	27.3 MiB

Quantile statistics

Minimum	1000
5-th percentile	3200
Q1	8000
median	12125
Q3	20000
95-th percentile	35000
Maximum	40000
Range	39000
Interquartile range (IQR)	12000

Descriptive statistics

Standard deviation	9002.6375
Coefficient of variation (CV)	0.61072978
Kurtosis	-0.087397524
Mean	14740.787
Median Absolute Deviation (MAD)	5875
Skewness	0.78892546
Sum	2.6339825 × 10¹⁰
Variance	81047481
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10000	140497	7.9%
20000	98004	5.5%
15000	94961	5.3%
12000	94778	5.3%
35000	67528	3.8%
5000	66598	3.7%
8000	61975	3.5%
6000	58480	3.3%
16000	50476	2.8%
25000	48353	2.7%
Other values (1551)	1005217	56.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1000	7873	0.4%
1025	30	< 0.1%
1050	45	< 0.1%
1075	22	< 0.1%
1100	225	< 0.1%
1125	38	< 0.1%
1150	33	< 0.1%
1175	15	< 0.1%
1200	3106	0.2%
1225	16	< 0.1%

Value	Count	Frequency (%)
40000	18897	1.1%
39975	10	< 0.1%
39950	5	< 0.1%
39925	6	< 0.1%
39900	13	< 0.1%
39875	5	< 0.1%
39850	4	< 0.1%
39825	10	< 0.1%
39800	10	< 0.1%
39775	10	< 0.1%

loan_status
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	15.3 MiB

Fully Paid	1422806
Non-Performing	364061

Length

Max length	14
Median length	10
Mean length	10.814971
Min length	10

Characters and Unicode

Total characters	19324914
Distinct characters	18
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Fully Paid
2nd row	Fully Paid
3rd row	Fully Paid
4th row	Fully Paid
5th row	Fully Paid

Common Values

Value	Count	Frequency (%)
Fully Paid	1422806	79.6%
Non-Performing	364061	20.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
fully	1422806	44.3%
paid	1422806	44.3%
non-performing	364061	11.3%

Most occurring characters

Value	Count	Frequency (%)
l	2845612	14.7%
P	1786867	9.2%
i	1786867	9.2%
F	1422806	7.4%
y	1422806	7.4%
	1422806	7.4%
a	1422806	7.4%
d	1422806	7.4%
u	1422806	7.4%
r	728122	3.8%
Other values (8)	3640610	18.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	19324914	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
l	2845612	14.7%
P	1786867	9.2%
i	1786867	9.2%
F	1422806	7.4%
y	1422806	7.4%
	1422806	7.4%
a	1422806	7.4%
d	1422806	7.4%
u	1422806	7.4%
r	728122	3.8%
Other values (8)	3640610	18.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	19324914	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
l	2845612	14.7%
P	1786867	9.2%
i	1786867	9.2%
F	1422806	7.4%
y	1422806	7.4%
	1422806	7.4%
a	1422806	7.4%
d	1422806	7.4%
u	1422806	7.4%
r	728122	3.8%
Other values (8)	3640610	18.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	19324914	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
l	2845612	14.7%
P	1786867	9.2%
i	1786867	9.2%
F	1422806	7.4%
y	1422806	7.4%
	1422806	7.4%
a	1422806	7.4%
d	1422806	7.4%
u	1422806	7.4%
r	728122	3.8%
Other values (8)	3640610	18.8%

pub_rec
Real number (ℝ)

ZEROS

Distinct	42
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.21426721

Minimum	0
Maximum	86
Zeros	1483020
Zeros (%)	83.0%
Negative	0
Negative (%)	0.0%
Memory size	27.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	1
Maximum	86
Range	86
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.59843255
Coefficient of variation (CV)	2.7929265
Kurtosis	723.40073
Mean	0.21426721
Median Absolute Deviation (MAD)	0
Skewness	11.642548
Sum	382867
Variance	0.35812151
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=42)

Value	Count	Frequency (%)
0	1483020	83.0%
1	256949	14.4%
2	30575	1.7%
3	9431	0.5%
4	3440	0.2%
5	1648	0.1%
6	827	< 0.1%
7	377	< 0.1%
8	212	< 0.1%
9	118	< 0.1%
Other values (32)	270	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1483020	83.0%
1	256949	14.4%
2	30575	1.7%
3	9431	0.5%
4	3440	0.2%
5	1648	0.1%
6	827	< 0.1%
7	377	< 0.1%
8	212	< 0.1%
9	118	< 0.1%

Value	Count	Frequency (%)
86	1	< 0.1%
63	1	< 0.1%
61	2	< 0.1%
54	1	< 0.1%
52	1	< 0.1%
49	2	< 0.1%
47	1	< 0.1%
46	1	< 0.1%
45	1	< 0.1%
44	1	< 0.1%

pub_rec_bankruptcies
Real number (ℝ)

ZEROS

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.1367343

Minimum	0
Maximum	12
Zeros	1558818
Zeros (%)	87.2%
Negative	0
Negative (%)	0.0%
Memory size	27.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	1
Maximum	12
Range	12
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.37780133
Coefficient of variation (CV)	2.7630327
Kurtosis	18.440094
Mean	0.1367343
Median Absolute Deviation (MAD)	0
Skewness	3.3223977
Sum	244326
Variance	0.14273385
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
0	1558818	87.2%
1	215686	12.1%
2	9645	0.5%
3	1945	0.1%
4	502	< 0.1%
5	178	< 0.1%
6	58	< 0.1%
7	21	< 0.1%
8	9	< 0.1%
9	3	< 0.1%
Other values (2)	2	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1558818	87.2%
1	215686	12.1%
2	9645	0.5%
3	1945	0.1%
4	502	< 0.1%
5	178	< 0.1%
6	58	< 0.1%
7	21	< 0.1%
8	9	< 0.1%
9	3	< 0.1%

Value	Count	Frequency (%)
12	1	< 0.1%
11	1	< 0.1%
9	3	< 0.1%
8	9	< 0.1%
7	21	< 0.1%
6	58	< 0.1%
5	178	< 0.1%
4	502	< 0.1%
3	1945	0.1%
2	9645	0.5%

purpose
Categorical

Distinct	14
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	15.3 MiB

debt_consolidation	1027147
credit_card	403867
home_improvement	117900
other	105842
major_purchase	38359
Other values (9)	93752

Length

Max length	18
Median length	18
Mean length	14.875992
Min length	3

Characters and Unicode

Total characters	26581420
Distinct characters	22
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	debt_consolidation
2nd row	home_improvement
3rd row	debt_consolidation
4th row	debt_consolidation
5th row	debt_consolidation

Common Values

Value	Count	Frequency (%)
debt_consolidation	1027147	57.5%
credit_card	403867	22.6%
home_improvement	117900	6.6%
other	105842	5.9%
major_purchase	38359	2.1%
medical	21173	1.2%
car	17905	1.0%
small_business	17634	1.0%
vacation	12503	0.7%
moving	12158	0.7%
Other values (4)	12379	0.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
debt_consolidation	1027147	57.5%
credit_card	403867	22.6%
home_improvement	117900	6.6%
other	105842	5.9%
major_purchase	38359	2.1%
medical	21173	1.2%
car	17905	1.0%
small_business	17634	1.0%
vacation	12503	0.7%
moving	12158	0.7%
Other values (4)	12379	0.7%

Most occurring characters

Value	Count	Frequency (%)
o	3496508	13.2%
d	2884935	10.9%
t	2694408	10.1%
i	2640397	9.9%
n	2217573	8.3%
e	1984533	7.5%
c	1924823	7.2%
_	1606015	6.0%
a	1590562	6.0%
s	1146445	4.3%
Other values (12)	4395221	16.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	26581420	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
o	3496508	13.2%
d	2884935	10.9%
t	2694408	10.1%
i	2640397	9.9%
n	2217573	8.3%
e	1984533	7.5%
c	1924823	7.2%
_	1606015	6.0%
a	1590562	6.0%
s	1146445	4.3%
Other values (12)	4395221	16.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	26581420	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
o	3496508	13.2%
d	2884935	10.9%
t	2694408	10.1%
i	2640397	9.9%
n	2217573	8.3%
e	1984533	7.5%
c	1924823	7.2%
_	1606015	6.0%
a	1590562	6.0%
s	1146445	4.3%
Other values (12)	4395221	16.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	26581420	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
o	3496508	13.2%
d	2884935	10.9%
t	2694408	10.1%
i	2640397	9.9%
n	2217573	8.3%
e	1984533	7.5%
c	1924823	7.2%
_	1606015	6.0%
a	1590562	6.0%
s	1146445	4.3%
Other values (12)	4395221	16.5%

revol_bal
Real number (ℝ)

Distinct	93558
Distinct (%)	5.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	16471.303

Minimum	0
Maximum	2904836
Zeros	6822
Zeros (%)	0.4%
Negative	0
Negative (%)	0.0%
Memory size	27.3 MiB

Quantile statistics

Minimum	0
5-th percentile	1705
Q1	5967
median	11205
Q3	19950
95-th percentile	44318
Maximum	2904836
Range	2904836
Interquartile range (IQR)	13983

Descriptive statistics

Standard deviation	22641.686
Coefficient of variation (CV)	1.3746141
Kurtosis	576.46018
Mean	16471.303
Median Absolute Deviation (MAD)	6227
Skewness	12.566874
Sum	2.9432028 × 10¹⁰
Variance	5.1264594 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	6822	0.4%
8	174	< 0.1%
6312	139	< 0.1%
5453	132	< 0.1%
10	130	< 0.1%
2	130	< 0.1%
5232	128	< 0.1%
5891	128	< 0.1%
5570	128	< 0.1%
4427	127	< 0.1%
Other values (93548)	1778829	99.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	6822	0.4%
1	93	< 0.1%
2	130	< 0.1%
3	123	< 0.1%
4	115	< 0.1%
5	108	< 0.1%
6	116	< 0.1%
7	98	< 0.1%
8	174	< 0.1%
9	119	< 0.1%

Value	Count	Frequency (%)
2904836	1	< 0.1%
2568995	1	< 0.1%
2560703	1	< 0.1%
1746716	1	< 0.1%
1743266	1	< 0.1%
1696796	1	< 0.1%
1470945	1	< 0.1%
1392002	1	< 0.1%
1298783	1	< 0.1%
1190046	1	< 0.1%

revol_util
Real number (ℝ)

Distinct	1305
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.50390201

Minimum	0
Maximum	3.666
Zeros	8308
Zeros (%)	0.5%
Negative	0
Negative (%)	0.0%
Memory size	27.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0.096
Q1	0.317
median	0.504
Q3	0.693
95-th percentile	0.909
Maximum	3.666
Range	3.666
Interquartile range (IQR)	0.376

Descriptive statistics

Standard deviation	0.24608243
Coefficient of variation (CV)	0.48835374
Kurtosis	-0.80744199
Mean	0.50390201
Median Absolute Deviation (MAD)	0.188
Skewness	-0.0066285781
Sum	900405.87
Variance	0.060556563
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	8308	0.5%
0.57	3472	0.2%
0.48	3470	0.2%
0.59	3438	0.2%
0.58	3428	0.2%
0.53	3413	0.2%
0.61	3398	0.2%
0.54	3362	0.2%
0.55	3361	0.2%
0.46	3340	0.2%
Other values (1295)	1747877	97.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	8308	0.5%
0.001	1378	0.1%
0.002	1129	0.1%
0.003	1041	0.1%
0.004	900	0.1%
0.005	862	< 0.1%
0.006	790	< 0.1%
0.007	772	< 0.1%
0.008	753	< 0.1%
0.009	737	< 0.1%

Value	Count	Frequency (%)
3.666	1	< 0.1%
1.93	1	< 0.1%
1.846	1	< 0.1%
1.828	1	< 0.1%
1.803	1	< 0.1%
1.777	1	< 0.1%
1.72	1	< 0.1%
1.669	1	< 0.1%
1.658	1	< 0.1%
1.62	1	< 0.1%

sub_grade
Categorical

Distinct	35
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	15.3 MiB

C1	114557
B5	111747
B4	111161
C2	104058
B3	103952
Other values (30)	1241392

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	3573734
Distinct characters	12
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	B2
2nd row	B2
3rd row	B2
4th row	A3
5th row	B4

Common Values

Value	Count	Frequency (%)
C1	114557	6.4%
B5	111747	6.3%
B4	111161	6.2%
C2	104058	5.8%
B3	103952	5.8%
C3	101008	5.7%
C4	100459	5.6%
B1	98596	5.5%
B2	98341	5.5%
C5	92768	5.2%
Other values (25)	750220	42.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
c1	114557	6.4%
b5	111747	6.3%
b4	111161	6.2%
c2	104058	5.8%
b3	103952	5.8%
c3	101008	5.7%
c4	100459	5.6%
b1	98596	5.5%
b2	98341	5.5%
c5	92768	5.2%
Other values (25)	750220	42.0%

Most occurring characters

Value	Count	Frequency (%)
B	523797	14.7%
C	512850	14.4%
1	387814	10.9%
4	354600	9.9%
2	351577	9.8%
5	351426	9.8%
3	341450	9.6%
A	329095	9.2%
D	265392	7.4%
E	110811	3.1%
Other values (2)	44922	1.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	3573734	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
B	523797	14.7%
C	512850	14.4%
1	387814	10.9%
4	354600	9.9%
2	351577	9.8%
5	351426	9.8%
3	341450	9.6%
A	329095	9.2%
D	265392	7.4%
E	110811	3.1%
Other values (2)	44922	1.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	3573734	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
B	523797	14.7%
C	512850	14.4%
1	387814	10.9%
4	354600	9.9%
2	351577	9.8%
5	351426	9.8%
3	341450	9.6%
A	329095	9.2%
D	265392	7.4%
E	110811	3.1%
Other values (2)	44922	1.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	3573734	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
B	523797	14.7%
C	512850	14.4%
1	387814	10.9%
4	354600	9.9%
2	351577	9.8%
5	351426	9.8%
3	341450	9.6%
A	329095	9.2%
D	265392	7.4%
E	110811	3.1%
Other values (2)	44922	1.3%

term
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	15.3 MiB

36	1333907
60	452960

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	3573734
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	36
2nd row	36
3rd row	36
4th row	36
5th row	36

Common Values

Value	Count	Frequency (%)
36	1333907	74.7%
60	452960	25.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
36	1333907	74.7%
60	452960	25.3%

Most occurring characters

Value	Count	Frequency (%)
6	1786867	50.0%
3	1333907	37.3%
0	452960	12.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	3573734	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
6	1786867	50.0%
3	1333907	37.3%
0	452960	12.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	3573734	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
6	1786867	50.0%
3	1333907	37.3%
0	452960	12.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	3573734	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
6	1786867	50.0%
3	1333907	37.3%
0	452960	12.7%

verification_status
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	15.3 MiB

Source Verified	714425
Not Verified	560906
Verified	511536

Length

Max length	15
Median length	12
Mean length	12.054358
Min length	8

Characters and Unicode

Total characters	21539535
Distinct characters	13
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Not Verified
2nd row	Source Verified
3rd row	Verified
4th row	Not Verified
5th row	Not Verified

Common Values

Value	Count	Frequency (%)
Source Verified	714425	40.0%
Not Verified	560906	31.4%
Verified	511536	28.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
verified	1786867	58.4%
source	714425	23.3%
not	560906	18.3%

Most occurring characters

Value	Count	Frequency (%)
e	4288159	19.9%
i	3573734	16.6%
r	2501292	11.6%
V	1786867	8.3%
f	1786867	8.3%
d	1786867	8.3%
o	1275331	5.9%
	1275331	5.9%
S	714425	3.3%
u	714425	3.3%
Other values (3)	1836237	8.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	21539535	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	4288159	19.9%
i	3573734	16.6%
r	2501292	11.6%
V	1786867	8.3%
f	1786867	8.3%
d	1786867	8.3%
o	1275331	5.9%
	1275331	5.9%
S	714425	3.3%
u	714425	3.3%
Other values (3)	1836237	8.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	21539535	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	4288159	19.9%
i	3573734	16.6%
r	2501292	11.6%
V	1786867	8.3%
f	1786867	8.3%
d	1786867	8.3%
o	1275331	5.9%
	1275331	5.9%
S	714425	3.3%
u	714425	3.3%
Other values (3)	1836237	8.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	21539535	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	4288159	19.9%
i	3573734	16.6%
r	2501292	11.6%
V	1786867	8.3%
f	1786867	8.3%
d	1786867	8.3%
o	1275331	5.9%
	1275331	5.9%
S	714425	3.3%
u	714425	3.3%
Other values (3)	1836237	8.5%

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	addr_state	annual_inc	application_type	avg_cur_bal	bc_util	delinq_2yrs	dti	emp_length	emp_title	fico_range_high	fico_range_low	grade	home_ownership	inq_last_6mths	installment	int_rate	issue_d	loan_amnt	loan_status	pub_rec	pub_rec_bankruptcies	purpose	revol_bal	revol_util	sub_grade	term	verification_status
42536	NC	60000.0	Individual	476.0	15.9	0.0	4.62	4	PROJECT_MANAGER	724.0	720.0	B	RENT	1.0	392.81	0.1099	2013-12-01	12000.0	Fully Paid	0.0	0.0	debt_consolidation	7137.0	0.240	B2	36	Not Verified
42537	TX	39600.0	Individual	1379.0	16.1	0.0	2.49	2	SURGICAL_TECHNICIAN	759.0	755.0	B	MORTGAGE	2.0	157.13	0.1099	2013-12-01	4800.0	Fully Paid	0.0	0.0	home_improvement	4136.0	0.161	B2	36	Source Verified
42538	MI	55000.0	Individual	9570.0	53.9	0.0	22.87	10	TEAM_LEADERN_CUSTOMER_OPS_&_SYSTEMS	734.0	730.0	B	OWN	0.0	885.46	0.1099	2013-12-01	27050.0	Fully Paid	0.0	0.0	debt_consolidation	36638.0	0.612	B2	36	Verified
42539	TX	96500.0	Individual	11783.0	83.5	0.0	12.61	3	SYSTEMS_ENGINEER	709.0	705.0	A	MORTGAGE	0.0	373.94	0.0762	2013-12-01	12000.0	Fully Paid	0.0	0.0	debt_consolidation	13248.0	0.557	A3	36	Not Verified
42540	NC	88000.0	Individual	2945.0	87.7	1.0	10.02	4	ASSISTANT_DIRECTOR_-_HUMAN_RESOURCES	674.0	670.0	B	RENT	0.0	470.71	0.1285	2013-12-01	14000.0	Fully Paid	1.0	1.0	debt_consolidation	3686.0	0.819	B4	36	Not Verified
42541	CT	105000.0	Individual	26765.0	25.0	0.0	14.05	10	MANAGER_INFORMATION_DELIVERY	764.0	760.0	A	MORTGAGE	1.0	368.45	0.0662	2013-12-01	12000.0	Fully Paid	0.0	0.0	debt_consolidation	13168.0	0.216	A2	36	Not Verified
42542	FL	63000.0	Individual	38927.0	79.1	0.0	16.51	2	AIRCRAFT_MAINTENANCE_ENGINEER	674.0	670.0	A	MORTGAGE	0.0	476.30	0.0890	2013-12-01	15000.0	Fully Paid	0.0	0.0	debt_consolidation	11431.0	0.742	A5	36	Not Verified
42543	CA	28000.0	Individual	1440.0	96.0	0.0	8.40	3	SPECIAL_ORDER_FULFILLMENT_CLERK	664.0	660.0	C	RENT	0.0	266.34	0.1624	2013-12-01	7550.0	Fully Paid	0.0	0.0	debt_consolidation	5759.0	0.720	C5	36	Not Verified
42544	CA	325000.0	Individual	53306.0	67.1	0.0	18.55	5	AREA_SALES_MANAGER	749.0	745.0	A	MORTGAGE	1.0	872.52	0.0762	2013-12-01	28000.0	Fully Paid	0.0	0.0	debt_consolidation	29581.0	0.546	A3	36	Source Verified
42545	CO	130000.0	Individual	36362.0	93.0	0.0	13.03	10	LTC	719.0	715.0	B	MORTGAGE	1.0	398.52	0.1199	2013-12-01	12000.0	Fully Paid	0.0	0.0	debt_consolidation	10805.0	0.670	B3	36	Source Verified

	acc_now_delinq	addr_state	annual_inc	application_type	avg_cur_bal	bc_util	delinq_2yrs	dti	emp_length	emp_title	fico_range_high	fico_range_low	grade	home_ownership	inq_last_6mths	installment	int_rate	issue_d	loan_amnt	loan_status	pub_rec	pub_rec_bankruptcies	purpose	revol_bal	revol_util	sub_grade	term	verification_status
2925483	0.0	FL	32000.0	Joint App	2331.0	52.9	0.0	70.92	4	SALES_MANAGER	709.0	705.0	C	MORTGAGE	1.0	683.94	0.1399	2017-04-01	29400.0	Fully Paid	0.0	0.0	debt_consolidation	12264.0	0.461	C3	60	Source Verified
2925484	0.0	MD	180000.0	Individual	63816.0	68.0	0.0	10.41	5	BRANCH_MANAGER	679.0	675.0	E	OWN	4.0	1037.38	0.2549	2017-04-01	35000.0	Fully Paid	0.0	0.0	debt_consolidation	31233.0	0.580	E4	60	Source Verified
2925485	0.0	CA	64500.0	Individual	11056.0	67.3	0.0	9.66	10	FOREMAN	664.0	660.0	F	MORTGAGE	3.0	378.65	0.2869	2017-04-01	12000.0	Fully Paid	1.0	1.0	home_improvement	16478.0	0.513	F1	60	Not Verified
2925486	0.0	IL	100000.0	Individual	28408.0	14.2	0.0	8.32	0	INDUSTRIAL_ENGINEER	689.0	685.0	C	MORTGAGE	1.0	814.21	0.1399	2017-04-01	35000.0	Fully Paid	1.0	1.0	debt_consolidation	3162.0	0.142	C3	60	Source Verified
2925487	0.0	CA	53000.0	Individual	4113.0	92.1	0.0	24.65	0	NaN	664.0	660.0	E	RENT	0.0	538.40	0.2274	2017-04-01	19200.0	Non-Performing	0.0	0.0	debt_consolidation	23058.0	0.769	E1	60	Source Verified
2925488	0.0	CO	107000.0	Individual	5528.0	26.0	3.0	11.65	0	SENIOR_ESCROW_OFFICER	674.0	670.0	E	RENT	1.0	690.30	0.2399	2017-04-01	24000.0	Non-Performing	2.0	1.0	other	9688.0	0.249	E2	60	Source Verified
2925489	0.0	PA	65000.0	Individual	3724.0	24.6	1.0	19.55	10	NURSE	729.0	725.0	A	MORTGAGE	0.0	313.32	0.0799	2017-04-01	10000.0	Fully Paid	0.0	0.0	debt_consolidation	9751.0	0.157	A5	36	Source Verified
2925490	0.0	VA	37000.0	Individual	1021.0	66.1	0.0	20.56	8	SALES_ASSOCIATE	709.0	705.0	D	RENT	1.0	358.26	0.1699	2017-04-01	10050.0	Non-Performing	0.0	0.0	debt_consolidation	14300.0	0.470	D1	36	Not Verified
2925491	1.0	NY	41000.0	Individual	3275.0	5.5	1.0	19.99	5	CONTACT_INPUT	674.0	670.0	B	RENT	0.0	197.69	0.1144	2017-04-01	6000.0	Fully Paid	0.0	0.0	credit_card	1356.0	0.101	B4	36	Source Verified
2925492	0.0	TX	105700.0	Individual	19955.0	80.6	1.0	27.26	4	ASSISTANT_MANAGER	699.0	695.0	E	MORTGAGE	0.0	889.18	0.2549	2017-04-01	30000.0	Non-Performing	0.0	0.0	debt_consolidation	15252.0	0.726	E4	60	Verified

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories